package com.ruoyi.system.mapper;

import java.util.ArrayList;
import java.util.List;

import com.ruoyi.system.domain.Echarts;
import com.ruoyi.system.domain.StuCertificate;

/**
 * 资格证书Mapper接口
 * 
 * @author ruoyi
 * @date 2024-01-09
 */
public interface StuCertificateMapper 
{
    /**
     * 查询资格证书
     * 
     * @param cerId 资格证书主键
     * @return 资格证书
     */
    public StuCertificate selectStuCertificateByCerId(Long cerId);

    /**
     * 查询资格证书列表
     * 
     * @param stuCertificate 资格证书
     * @return 资格证书集合
     */
    public List<StuCertificate> selectStuCertificateList(StuCertificate stuCertificate);

    /**
     * 新增资格证书
     * 
     * @param stuCertificate 资格证书
     * @return 结果
     */
    public int insertStuCertificate(StuCertificate stuCertificate);

    /**
     * 修改资格证书
     * 
     * @param stuCertificate 资格证书
     * @return 结果
     */
    public int updateStuCertificate(StuCertificate stuCertificate);

    /**
     * 删除资格证书
     * 
     * @param cerId 资格证书主键
     * @return 结果
     */
    public int deleteStuCertificateByCerId(Long cerId);

    /**
     * 批量删除资格证书
     * 
     * @param cerIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteStuCertificateByCerIds(String[] cerIds);

    /**
     * 查询删除资格证书
     *
     * @param cerIds 需要查询的数据主键集合
     * @return 结果
     */
    public List<StuCertificate> selectStuCertificateByCerIds(String[] cerIds);
    public List<StuCertificate> selectStuCertificateByUserIdList(StuCertificate stuCertificate);

    public List<StuCertificate> selectAllocatedList(StuCertificate stuCertificate);

    public List<StuCertificate> selectUnallocatedList(StuCertificate stuCertificate);
    public int updateExpiredStatus();
    public ArrayList<Echarts> IsExpiredCount(StuCertificate stuCertificate);
}
